package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.utils.DBUtility;


/**
 * ���ù�j��ϵ��servlet
 * @author Administrator
 *
 */
public class SetRelationServlet extends HttpServlet {

	
	private static final long serialVersionUID = -429690291017733512L;
	private Connection conn;
	private PreparedStatement pst;
	private ResultSet rs;
	
	public SetRelationServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			this.doPost(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		System.out.println("SetRelationServlet=======>�ͻ��˷��ʿ�ʼ��ȡ���:");
		
		String user_id = request.getParameter( "id" );
		String bind_phonenum = request.getParameter( "bind_phonenum" );
		
		bindNewRelationship(user_id,bind_phonenum);
	}

	
	
	private void bindNewRelationship( String user_id, String bind_phonenum ){
		System.out.println("SetRelationServlet=======>�ͻ��˿�ʼ��");
		System.out.println("SetRelationServlet=======>���û��˺�" + user_id +"���ֻ����" + bind_phonenum +"���а�");
		
		String sql = "insert into jiankong_realations_table(user_account,jiankong_object,id) values(?,?,jiangkong_relat_table_seq.nextval)";
		
		conn = DBUtility.getMySqlConnection();
		
		try {
			pst = conn.prepareStatement( sql );
			pst.setString( 1, user_id);
			pst.setString( 2, bind_phonenum);
			int i = pst.executeUpdate();
			
			if( i > 0 ){
				System.out.println("SetRelationServlet=======>�û��˺ź��ֻ�Ű󶨳ɹ�");
			}else{
				System.out.println("SetRelationServlet=======>�û��˺ź��ֻ�Ű�ʧ��");
			}
			  
				
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("SetRelationServlet=======>���򱨴�---" + e.getMessage());
			e.printStackTrace();
		}finally{
			
			closeAllConnections();
			
		}
		
	}
	
	/**
	 * �ر����е�l��
	 */
	private void closeAllConnections(){
		if( pst != null){
			
			try {
				pst.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		if( conn != null ){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		System.out.println("SetRelationServlet=====>�ر�l��"); 
	}
	public void init() throws ServletException {
		// Put your code here
	}

}
